| syDictionary |
| Logical Entity Name | syDictionary |
| Default Table Name | syDictionary |
| Physical Only | NO |
| Owner | dbo |
| Definition | |
| Note |
| syDictionary Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
syDictionaryID |
int | NO | ||
| TableName | varchar(255) | YES | ||
| ColumnName | varchar(255) | YES | ||
| ColSeq | int | NO | ||
| ColType | varchar(20) | YES | ||
| MaxLength | int | YES | ||
| English | varchar(255) | YES | ||
| Spanish | varchar(255) | YES | ||
| Other | varchar(255) | YES | ||
| SystemRequired | bit | NO | ||
| UserRequired | bit | NO | ||
| UserUpdatable | bit | NO | ||
| ShowOnWeb | bit | NO | ||
| Security | bit | NO | ||
| EnglishToolTip | varchar(255) | YES | ||
| SpanishToolTip | varchar(255) | YES | ||
| OtherToolTip | varchar(255) | YES | ||
| Audit | bit | NO | ||
| Comment | text | YES | ||
| Helpid | int | NO | ||
| InputMask | varchar(35) | YES | ||
| SQLColType | varchar(20) | YES | ||
| SQLLength | int | YES | ||
| SQLScale | tinyint | YES | ||
| SQLPrecision | int | YES | ||
| SQLNulls | bit | NO | ||
| SQLDefault | varchar(500) | YES | ||
| DateAdded | datetime | YES | ||
| UserID | int | NO | ||
| DateLstMod | datetime | YES | ||
| ts | timestamp | NO | ||
| IsEnabledForCDC | bit | NO | ||
| SchemaName | nvarchar(255) | NO | ||
| PTDisplayInUI | bit | NO | ||
| EntityName | varchar(255) | YES | ||
| PropertyName | varchar(255) | YES | ||
| ModuleName | varchar(255) | YES | ||
| IsColumnLocalizable | bit | YES | ||
| IsLangKeyColumn | bit | YES | ||
| IntroducedVersion | nvarchar(10) | YES |
| syDictionary Primary and Unique Keys |
| Key Name | Key Type | Keys |
| syDictionary_SyDictionaryID_U_C_IDX | PrimaryKey | syDictionaryID |
| syDictionary_TableName_ColSeq_ColumnName_U_C_IDX | Index | TableName, ColumnName, ColSeq |
| syDictionary_syDictionaryID_U_N_IDX | Index | syDictionaryID |
| syDictionary_TableName_ColumnName_U_N_IDX | Index | TableName, ColumnName, SchemaName |
| syDictionary Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| syDictionary Check Constraints |
| Check Constraint Name | CheckConstraint |
| syDictionary Storage |
| STORAGE OPTION | STORAGE VALUE |
| Filegroup | PRIMARY |
| Text Image File Group | PRIMARY |
| syDictionary Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical dbo.DataDictionaryColumn |
NO | |||
| Physical (Microsoft SQL Server) dbo.syDictionary |
NO |
| syDictionary Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Physical (Microsoft SQL Server) | Main Model |
| Physical (Microsoft SQL Server) | System |
| syDictionary Data Movement Rules |
| Name | Type | Rule Text/Value |